DividendTaxRates

V8 Message Definiton

Records in this table define the withholding tax rate applied to discrete dividends for option pricing, keyed by ISO 3166 country code. The effective dividend seen by the option holder is: dividendAmount * (1 - withholdingRate). Example: US = 0.0 (no withholding), DE = 0.2 (20% withheld, 80% to trader).

METADATA

Attribute	Value
Topic	3585-option-pricing
MLink Token	EqtAnalytics
Product	SRAnalytics
accessType	SELECT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
countryCode	VARCHAR(3)	PRI	''	domicile of the exchange ISO 3166
withholdingRate	FLOAT		0	fraction of dividend withheld as tax 00 no withholding NMS 02 20 withheld EUREX
modifiedBy	VARCHAR(24)		''
modifiedIn	enum - SysEnvironment		'None'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
countryCode	1

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRAnalytics`.`MsgDividendTaxRates`
WHERE 
    /* Replace with a VARCHAR(3) */ 
    `countryCode` = 'Example_countryCode';

Doc Columns Query

SELECT * FROM SRAnalytics.doccolumns WHERE TABLE_NAME='DividendTaxRates' ORDER BY ordinal_position ASC;